* variable edits
drop brandgeneric	// all products should be brand
drop clientdrugflag // empty variable
drop processingdate	// variable for version control only
drop clientid		// pretty sure it means us
drop productclass	// we have this information in a different file

* destring IDs
destring medid, replace

* format period as a monthly variable
gen m = ym(real(substr(period,1,4)), real(substr(period,-2,2)))
format m %tm
drop period

* harmonize drug names
replace drugname = upper(trim(drugname))
